In situations where the direct use of the JDBC connection is not possible, transaction statements can be used to control a local transaction.

• START TRANSACTION- synonym for connection.setAutoCommit(false)

• COMMIT- synonym for connection.setAutoCommit(true)

• ROLLBACK- synonym for connection.rollback() and returning to auto commit mode.